Edinburgh’s road network

Edinburgh’s implementation zones

Edinburgh’s control zones

Time series analysis

Mapping accidents with roads: 2013

##                    LAYER Accident_Index
## 1 20mph existing streets             47
## 2    20mph local streets             73
## 3     20mph main streets            180
## 4                  30mph             96
##   Speed_limit Accident_Index
## 1          20             25
## 2          30            371

Mapping accidents with roads: 2014

##                    LAYER Accident_Index
## 1 20mph existing streets            159
## 2    20mph local streets            155
## 3     20mph main streets            386
## 4                  30mph            261
##   Speed_limit Accident_Index
## 1          20             37
## 2          30            924

Mapping accidents with roads: 2015

##                    LAYER Accident_Index
## 1 20mph existing streets            105
## 2    20mph local streets            152
## 3     20mph main streets            328
## 4                  30mph            249
##   Speed_limit Accident_Index
## 1          20             34
## 2          30            800

Mapping accidents with roads: 2016

##                    LAYER Accident_Index
## 1 20mph existing streets             47
## 2    20mph local streets             54
## 3     20mph main streets             25
## 4                  30mph             27
##   Speed_limit Accident_Index
## 1          20              8
## 2          30            145

Mapping accidents with roads: 2018

##                    LAYER Accident_Index
## 1 20mph existing streets             62
## 2    20mph local streets             83
## 3     20mph main streets            181
## 4                  30mph            140
##   Speed_limit Accident_Index
## 1          20            288
## 2          30            178

Mapping accidents with roads: 2019

##                    LAYER Accident_Index
## 1 20mph existing streets             33
## 2    20mph local streets             50
## 3     20mph main streets             87
## 4                  30mph             75
##   Speed_limit Accident_Index
## 1          20            153
## 2          30             92

Count pre 20mph

##                    LAYER Accident_Index
## 1 20mph existing streets            358
## 2    20mph local streets            434
## 3     20mph main streets            919
## 4                  30mph            633
##   Speed_limit Accident_Index
## 1          20            104
## 2          30           2240

Count post 20mph

##                    LAYER Accident_Index
## 1 20mph existing streets             95
## 2    20mph local streets            133
## 3     20mph main streets            268
## 4                  30mph            215
##   Speed_limit Accident_Index
## 1          20            441
## 2          30            270

Output column: Layer

##     ID Speed_limit              LAYER
## 1 1404          30              30mph
## 2  923          30 20mph main streets
## 3 2315          30              30mph
## 4 1504          30              30mph
## 5 2183          30              30mph
## 6  143          30 20mph main streets

Table: Average annual road traffic collision rates in the city of Edinburgh ( GIS )

Table 1: Average annual road traffic collision rates in the city of Edinburgh (GIS)
Type collisions pre-20mph collisions post-20mph rate pre-20mph rate post-20mph diff in rates Perc.diff.rates
Streets at 30mph 633 215 211.00 215 4.00 2
Streets at 20mph 358 95 119.33 95 -24.33 -20
Streets at 30mph changed to 20mph 1353 401 451.00 401 -50.00 -11
All streets 2344 711 781.33 711 -70.33 -9

Table: Average annual road traffic collision rates in the city of Edinburgh ( Stats19 )

Table 2: Average annual road traffic collision rates in the city of Edinburgh (Stats19)
Type collisions pre-20mph collisions post-20mph rate pre-20mph rate post-20mph diff in rates Perc.diff.rates
Streets at 20mph 104 441 34.67 441 406.33 1172
Streets at 30mph 2240 270 746.67 270 -476.67 -64
All streets 2344 711 781.33 711 -70.33 -9

Effect estimate ( GIS )

Effect estimate(GIS)
Tax year 2013/14 2014/15 2015/16 2018/19
Annual number of collisions 949 860 535 711
Effect estimate -14.58

Effect estimate ( Stats19 )

Effect estimate(Stats19)
Tax year 2013/14 2014/15 2015/16 2018/19
Annual number of collisions 949 860 535 711
Effect estimate -14.58

Mapping accidents with implementation zones: 2013

##   ImplementationZone Accident_Index
## 1                  1             72
## 2                  2            104
## 3                  3            133
## 4                  4             38
## 5                  5             54
## 6                  6             26
## 7                  7             14

Mapping accidents with implementation zones: 2014

##   ImplementationZone Accident_Index
## 1                  1            168
## 2                  2            269
## 3                  3            290
## 4                  4             92
## 5                  5            114
## 6                  6             84
## 7                  7             40

Mapping accidents with implementation zones: 2015

##   ImplementationZone Accident_Index
## 1                  1            155
## 2                  2            208
## 3                  3            264
## 4                  4             63
## 5                  5            113
## 6                  6             80
## 7                  7             26

Mapping accidents with implementation zones: 2016

##   ImplementationZone Accident_Index
## 1                  1             96
## 2                  2            120
## 3                  3            141
## 4                  4             37
## 5                  5             41
## 6                  6             44
## 7                  7             15

Mapping accidents with implementation zones: 2018

##   ImplementationZone Accident_Index
## 1                  1             88
## 2                  2            120
## 3                  3            150
## 4                  4             48
## 5                  5             53
## 6                  6             38
## 7                  7             17

Mapping accidents with implementation zones: 2019

##   ImplementationZone Accident_Index
## 1                  1             42
## 2                  2             68
## 3                  3             77
## 4                  4             28
## 5                  5             21
## 6                  6             15
## 7                  7              4

Output column: Implementation Zone

##   Accident_Index Speed_limit ImplementationZone
## 1  2013950000001          30                  1
## 2  2013950000002          30                  2
## 3  2013950000003          30                  2
## 4  2013950000007          30                  1
## 5  2013950000010          30                  4
## 6  2013950000058          20                  7

Total accidents per zone

##   ImplementationZone Accident_Index
## 1                  1            621
## 2                  2            889
## 3                  3           1055
## 4                  4            306
## 5                  5            396
## 6                  6            287
## 7                  7            116

Control zone 1a:City center –> George St/Harbour, Aberdeen

## [1] 81

Control zone 1b:Rural west –> Tay Bridgehead & St Andrews

## [1] 58

Control zone 3:South central –> Dundee

## [1] 441

Control zone 4:North west -> Renfrew North, Renfrew South & Gallowhill, Paisley North West

## [1] 269

Control zone 5:West –> Glasgow Kelvin

## [1] 972

Control zone 6:South –> Paisley

## [1] 386

Updated dataset for Edinburgh

##   Accident_Index Speed_limit                  LAYER ImplementationZone
## 1        0000419          20     20mph main streets                  2
## 2        0000519          20    20mph local streets                  1
## 3        0001019          20                  30mph                  2
## 4        0001419          30                  30mph                  4
## 5        0002119          30                  30mph                  5
## 6        0002319          20 20mph existing streets                  3